How to Get Data Analysis in Excel?

Data Analysis is an Excel add-ins so you should enable it. Follow the below steps to enable it:

  1. Open your Excel file or open the Excel 2016
  2. Click on File in the top bar
  3. Click on Options in the opened vertical bar.
  4. The 'Excel Options' window will open and then click on Add-ins
  5. In the below click on Go button
  6. The Add-Ins window will open
  7. Enable the Data Analysis on the checkboxes
  8. Click on OK
  9. Go to the Data tab and find the Data Analysis icon.
Name: Hidden

Data Analysis Toolpak in Excel



How to Get Data Analysis in Excel?